#!/bin/sh
echo "select nname from client where parent_clname = 'client-$1' && cttype = 'reseller'" | kloxodb | tail -n+2
